An error occurred: (MySQLdb.ProgrammingError) (1146, "Table 'mydb.apt_list_4' doesn't exist")
[SQL:
select a.rgnCode, a.conAptCode, aptName, a.conAptNo, a.aptUnit, a.hoNum,
c.sido, c.gugun, c.dong, c.bjri, a.aptAddr, a.doroAddr, a.conYear, a.useArea, ifnull(a.danjyHonum, 0) danjyHonum
from
(select a.rgnCode, a.conAptCode, b.conAptNo,
if(min(a.aptName_max) = max(a.aptName_max), min(a.aptName_max), concat(min(a.aptName_max), '~', max(a.aptName_max))) aptName,
b.aptUnit, ifnull(round(b.useArea, 2), 0) useArea, ifnull(b.hoNum, 0) hoNum,
if(a.con_addrNum='', a.aptAddr, a.con_addrNum) aptAddr,
if(a.con_doroAddr='', a.doroAddr, a.con_doroAddr) doroAddr,
max(if(ifnull(a.useDateMin, '') ='', a.conYear_min, a.useDateMin)) conYear, max(a.hoNum) danjyHonum
from mydb.apt_list_4 a left join mydb.apt_list_4 b on a.aptNo=b.aptCode
where a.rgnCode like %s and a.conAptCode = %s
and b.aptUnit is not null and a.rgnCode=a.con_rgnCode and a.conAptCode=b.conAptCode and b.conAptNo is not null
group by a.rgnCode, conAptCode, conAptNo, b.aptUnit, useArea, hoNum, aptAddr, doroAddr
) a left join region_list c on a.rgnCode = c.rgnCode
order by a.aptUnit
]
[parameters: ('26410108%', '1048641')]
(Background on this error at: https://sqlalche.me/e/20/f405)